class AddFulltextIndexToBlog < ActiveRecord::Migration
  def self.up
    execute "ALTER TABLE `eusden`.`blog_entries` 
              ADD FULLTEXT INDEX `Fulltext_Index`(`title`, `body`), ENGINE = MyISAM
              ROW_FORMAT = DYNAMIC;"
  end

  def self.down
    execute "ALTER TABLE `eusden`.`blog_entries` DROP INDEX `Fulltext_Index`, ENGINE = InnoDB;"
  end
end
